﻿CREATE TABLE [dbo].[FloatDataFact]
(
	[Time] BIGINT NOT NULL , 
    [TagId] BIGINT NOT NULL, 
    [Value] FLOAT NULL, 
    [IsNan] BIT NOT NULL, 
    [IsInfinity] BIT NOT NULL, 
    PRIMARY KEY ([Time], [TagId]), 
    CONSTRAINT [FK_FloatDataFact_ToTime] FOREIGN KEY ([Time]) REFERENCES [TimeDim]([Minute]), 
    CONSTRAINT [FK_FloatDataFact_ToTag] FOREIGN KEY ([TagId]) REFERENCES [TagDim]([TagId])
)
